Assessment for Spreadsheets

نویسندگان

  • Alexandru Toader
  • Andrea Kohlhase
  • Michael Kohlhase
چکیده

Spreadsheets are tools to model personal, business and scientific data and to support decision-making based on such models. Moreover, spreadsheets are used for communicating data, models, and decisions, which makes the interpretability of spreadsheet intents an important consideration in the design of spreadsheet interaction. In this paper we will focus on the problem of model assessment, i.e., the process of passing judgements on a situation based on modeled spreadsheet data, for instance, the development of profit over time represented in a controlling spreadsheet. We introduce a framework for specifying, documenting and personalizing assessments semi-formally and a set of plugins for the Semantic Alliance Architecture that can visualize assessments to assist the (spreadsheet) user in her decision-making.

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Automating Spreadsheet Discovery & Risk Assessment

There have been many articles and mishaps published about the risks of uncontrolled spreadsheets in today’s business environment, including non-compliance, operational risk, errors, and fraud all leading to significant loss events. Spreadsheets fall into the realm of end user developed applications and are often absent the proper safeguards and controls an IT organization would enforce for ente...

متن کامل

An approach for the automated risk assessment of structural differences between spreadsheets (DiffXL)

This paper outlines an approach to manage and quantify the risks associated with changes made to spreadsheets. The methodology focuses on structural differences between spreadsheets and suggests a technique by which a risk analysis can be achieved in an automated environment. The paper offers an example that demonstrates how contiguous ranges of data can be mapped into a generic list of formula...

متن کامل

Risk Assessment For Spreadsheet Developments: Choosing Which Models to Audit

Errors in spreadsheet applications and models are alarmingly common (some authorities, with justification cite spreadsheets containing errors as the norm rather than the exception). Faced with this body of evidence, the auditor can be faced with a huge task the temptation may be to launch code inspections for every spreadsheet in an organisation. This can be very expensive and time-consuming. T...

متن کامل

What we understand is what we get: Assessment in Spreadsheets

In previous work we have studied how an explicit representation of background knowledge associated with a specific spreadsheet can be exploited to alleviate usability problems with spreadsheet-based applications. We have implemented this approach in the SACHS system to provide a semantic help system for spreadsheets applications. In this paper, we evaluate the (comprehension) coverage of SACHS ...

متن کامل

What you understand is what you get: Assessment in Spreadsheets

Spreadsheets are heavily employed in administration, financial forecasting, education, and science because of their intuitive, flexible, and direct approach to computation. In previous work we have studied how an explicit representation of the background knowledge associated with the spreadsheet can be exploited to alleviate usability problems with spreadsheet-based applications. The SACHS syst...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:

دوره   شماره 

صفحات  -

تاریخ انتشار 2015